package com.purplesoft.zettl.DatabaseTables;

import android.provider.BaseColumns;

public class TblPrices {

	public class Columns implements BaseColumns {
		// columns of table "tblPrices"
		public static final String Price = "Price";
		public static final String GroceryID = "GroceryID";
		public static final String Created = "Created";
		public static final String Modified = "Modified";
	}

	// table name
	public static final String tableName = "tblPrices";

	// SQL command to create table "tblPrices"
	public static final String createTable = "CREATE TABLE " + tableName + "("
			+ Columns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
			+ Columns.Price + " REAL, "
			+ Columns.GroceryID + " INTEGER, "
			+ Columns.Created + " TEXT, "
			+ Columns.Modified + " TEXT)";

}
